package com.cqu.lpss.mapper;

import com.cqu.lpss.pojo.PrjJoinCon;
import com.cqu.lpss.pojo.Projects;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface ProjectMapper {
    public Projects findByConId(String ConId);
    public int insert(
    String            prjConid,
    String             prjRealname,
    String             prjVirtname,
    String             prjUrl,
    java.sql.Timestamp prjCreatetime,
    java.sql.Timestamp prjUpdatetime);
    public List<PrjJoinCon> select_join(Integer prjStatus);
    public int uploadByConId(
            String            prjConid,
            String             prjRealname,
            String             prjVirtname,
            String             prjUrl,
            java.sql.Timestamp prjUpdatetime
    );
    public List<Projects> list_All();
    public int modifyFirstGrade(Integer prjIndex,Double firstGrade);
    public int modifyPrjStatus(Integer prjIndex,Integer prjStatus);
    public int modifyPrjPublishFirstGrade();
    public int havepublishfirstGrade();
    public Projects queryfirstscore(String conId);
    public List<Projects> passfirstPrj();
    public List<Projects> list_final();
    public int modifyFinalGrade(Integer prjIndex,Double finalGrade);
    public int updatepublishfinalscore();
    public int havepublishfinalscore();
    public Projects finalscorequery(String conId);
    public List<Projects> passfinalprj();
}
